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