UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '08b4kyJvRh53BhdDnxjseWmg+fw9BuM7VFIZGirL1Jw='
WHERE
key_id = 'ccadf7a927f97df282607c7c21a1bf5bf27eefb1892c94684b05df051df8e3da'
AND (
token = '08b4kyJvRh53BhdDnxjseWmg+fw9BuM7VFIZGirL1Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)