UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCmY2vufV9ymnS1o9eC3ex1J62Bi4/eUXqffdE5uFF8='
WHERE
key_id = 'd4adfbf3420b2b86e7601039695b0a3deb34b7b09bcbdef2aca1ab245fcb6798'
AND (
token = 'zCmY2vufV9ymnS1o9eC3ex1J62Bi4/eUXqffdE5uFF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)