UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EsxpSiWPNTSJqP5p2EGKaiObfozKqhaC0w6xLq/dNdo='
WHERE
key_id = 'f9114e2b93c6111b0d5d43a3192bb94130fb9ae9f08d298f73a2f0054ea0e2ef'
AND (
token = 'EsxpSiWPNTSJqP5p2EGKaiObfozKqhaC0w6xLq/dNdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)