UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWn9UPBW+B6eO/XOAoUX5q4LiBVmF6mqX1sVx379Ixo='
WHERE
key_id = 'c46c6cf8c128fe6b4b8874b95837f7116a61ce1fda5fbd2687aac22a9f9dd9dd'
AND (
token = 'VWn9UPBW+B6eO/XOAoUX5q4LiBVmF6mqX1sVx379Ixo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)