UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TjhvKOEwhmy73IpIKRv07gYcdYy9cqidrkdyr0As3xk='
WHERE
key_id = 'efc9f3e75f0e74f795a28b2cb12d7576ded06821f2cdbb55fc1a58be170a2e39'
AND (
token = 'TjhvKOEwhmy73IpIKRv07gYcdYy9cqidrkdyr0As3xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)