UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9Od0r2xnG5hJYXOpYmqjxIgLE8fuVpeDIYRCzl3JW8='
WHERE
key_id = '84fc42b18e19f8c25e9a3a9f1ae97cafa324ea81de842987175956310fe32f4c'
AND (
token = 'z9Od0r2xnG5hJYXOpYmqjxIgLE8fuVpeDIYRCzl3JW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)