UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YhHwI9NY5TOCSOtdQDxQVTf8llqORPKYHdngtsB/7O4='
WHERE
key_id = '6496169dddef41d91a9cf9bc192192a9a778ca4ce39e7dbd6c58d000a729b866'
AND (
token = 'YhHwI9NY5TOCSOtdQDxQVTf8llqORPKYHdngtsB/7O4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)