UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEKbzk31Np6pQTOi8FgGyWdgj1rSFCOZ4Y7uqWCyRCE='
WHERE
key_id = '8780273c2dab930bc0418707df3d65f27f811a5c2db97b94eb20015a2627c6e0'
AND (
token = 'pEKbzk31Np6pQTOi8FgGyWdgj1rSFCOZ4Y7uqWCyRCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)