UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4HYq6mOJpnNVRw5iBc6Ml4JKKC2MxQUvNi0yx9MFP4='
WHERE
key_id = 'f8963e6f855688eea7d3ae57776694654ef1e65d95b1f897c004fcf052bedf0d'
AND (
token = 'E4HYq6mOJpnNVRw5iBc6Ml4JKKC2MxQUvNi0yx9MFP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)