UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4hKbT/+hdGp+hNKLdqVk1uYQnXAo+gJIvSd+rSxoBU='
WHERE
key_id = 'd6f07977237fc4ad60b8730d0ce5604a81916f266ab223872680019e4c7d9d19'
AND (
token = 'C4hKbT/+hdGp+hNKLdqVk1uYQnXAo+gJIvSd+rSxoBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)