UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+lIhuEMhKC7LCreG/dU2G4orz3ZN0ZKOvI4Ark5kIE='
WHERE
key_id = '87fe7835b0a2e7cac35e1bc15d20dbdd9eacc395739c0312da33e74d1f3cc45a'
AND (
token = 'Z+lIhuEMhKC7LCreG/dU2G4orz3ZN0ZKOvI4Ark5kIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)