UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Jh1rddfXH0LAbKN+4HIsbLkoEao6qFrjZ+jtWA+HII='
WHERE
key_id = 'd6d0dce55aca2577434a00238488a998066b76606e084e8b170dc5a16c55e546'
AND (
token = '9Jh1rddfXH0LAbKN+4HIsbLkoEao6qFrjZ+jtWA+HII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)