UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TtHZBNpzOwePi6LSlBEMZ0QFbW81wRtZvgfmb7gZMB8='
WHERE
key_id = 'c9fc54e122a6bf542890b36775933de462322a5e95cb4aa2a681df8fd8280b11'
AND (
token = 'TtHZBNpzOwePi6LSlBEMZ0QFbW81wRtZvgfmb7gZMB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)