UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gq0Qr7X35zPPQyiUcIUgFHxPO+POKupsWZqaAL9Jvko='
WHERE
key_id = 'd7dcb23c2e05bebd5a0deba52f07e692732b51dc24233c3b96b8c71b4df8d461'
AND (
token = 'Gq0Qr7X35zPPQyiUcIUgFHxPO+POKupsWZqaAL9Jvko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)