UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8XpoRDXkaFZeDZsF0rQdlp2MGmd52iw71pWL/DtdEw='
WHERE
key_id = '47ebd4478a53bba83f914063373bee9a01f2a67ad749957cefc5a01486da5f54'
AND (
token = 'u8XpoRDXkaFZeDZsF0rQdlp2MGmd52iw71pWL/DtdEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)