UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NC4mDIGE6QjPT3ervG+2xw2HHMcUZfrY/xDpALCpcP0='
WHERE
key_id = '80df3a999580a75b3074764012feb7f2cca1a2c84f9703af6099bad776ea8803'
AND (
token = 'NC4mDIGE6QjPT3ervG+2xw2HHMcUZfrY/xDpALCpcP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)