UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8UZWyeOpvrhSjppJswtNwuqcZ7I3+QqOMzCiSuhFoRk='
WHERE
key_id = '121f7c18fe9a96a4b722d4759c0e512b26292c346643922da77df3b4ebf9d148'
AND (
token = '8UZWyeOpvrhSjppJswtNwuqcZ7I3+QqOMzCiSuhFoRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)