UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NJcU8R7UpYSINhS0jbSeyfGTw34IigHutgGbTJObm0='
WHERE
key_id = '96b3c719f7e0f1ca36e4a746a6a372aa441f847e3675a26e9142ccaaa9737cf7'
AND (
token = '2NJcU8R7UpYSINhS0jbSeyfGTw34IigHutgGbTJObm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)