UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bj7uVHwo//7pqRBhg1QGITkCCXYZekOg18XlB8jmBLI='
WHERE
key_id = 'e196908e5e0a3eb4d3612e9fa332b63b5f4f05d51c57ffa24a1c9a1e94a64e68'
AND (
token = 'Bj7uVHwo//7pqRBhg1QGITkCCXYZekOg18XlB8jmBLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)