UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0mj+laNQWm4MOqGhKZSU0w6LDhfCwPcYwBG2Aou14rs='
WHERE
key_id = '4b6603dbeedc9ff74387e2ea49cabbc3534c758d59da38df4fe6b4559297773e'
AND (
token = '0mj+laNQWm4MOqGhKZSU0w6LDhfCwPcYwBG2Aou14rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)