UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WIUxC74ZqLCjMUI5RBofPZLeLbGj+hrazUAbyffTd7I='
WHERE
key_id = 'c1d3a9c10cf934df7f175a3c56ca08d64efa02c0b76f4f043e86840929f6f1dc'
AND (
token = 'WIUxC74ZqLCjMUI5RBofPZLeLbGj+hrazUAbyffTd7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)