UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JW/W4zUJxLS512qF2pk1sjVPUY/qringirY1xrC9Qr8='
WHERE
key_id = '1c3e21bd9d3d8a2e80ca321ecb90642be14e368f1cfff75c6c6304b7f7b87f10'
AND (
token = 'JW/W4zUJxLS512qF2pk1sjVPUY/qringirY1xrC9Qr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)