UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yWk+9+Xq0y3R1VK8bxWx6izfqY5QrUUFGSb285J4YQ='
WHERE
key_id = 'a8ff83d2350d5ac55ad76ae9789d23386927c4a1363b12a27653b318485623d7'
AND (
token = '8yWk+9+Xq0y3R1VK8bxWx6izfqY5QrUUFGSb285J4YQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)