UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lwLxQtXuP2gaxOPPQlB4TEvqKsTwwnkULIWI2ZncfBI='
WHERE
key_id = 'c4f71a9d0c575719bc46c288e2bcebe605af1072c0c35bd3f621f26011919370'
AND (
token = 'lwLxQtXuP2gaxOPPQlB4TEvqKsTwwnkULIWI2ZncfBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)