UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IpKNfyPyRwpNREUTbhDQwPGFIHkaXTfznX/msz7hao='
WHERE
key_id = 'b9b38e59a8a593275022b2b3990e2f06fd72b7a7f9dd27116d307c51c87fe42c'
AND (
token = '/IpKNfyPyRwpNREUTbhDQwPGFIHkaXTfznX/msz7hao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)