UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7m69A9CpC8YvcM8mBW0Q3Ibd3wWBLTVLe4bPmKYln94='
WHERE
key_id = 'a1f447021c3d88a7d35f137e111a791185eb258d4be0fc6308c31314b5b15973'
AND (
token = '7m69A9CpC8YvcM8mBW0Q3Ibd3wWBLTVLe4bPmKYln94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)