UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mznGypYS0r55tbaayrNgao+Dynh4lMIHj+2nKN9szSA='
WHERE
key_id = '8f41b1ab2b3b573a750d452e66f40f1a29e0a4af3bbb27a7b0300edba925036e'
AND (
token = 'mznGypYS0r55tbaayrNgao+Dynh4lMIHj+2nKN9szSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)