UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hSW+BfO0hOxQJajUqHgGq2JQoGVnj1YtGLcsFqqh5O8='
WHERE
key_id = '0a85685d9c601aae9f1c1fe84aa4ac0c5bf4c645350ea2edfc8dc163aa75664a'
AND (
token = 'hSW+BfO0hOxQJajUqHgGq2JQoGVnj1YtGLcsFqqh5O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)