UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LmPz04zu4lyAJY5tf697xma+08Kyv03fZlgRRu50qb4='
WHERE
key_id = '0e4cf9cce75a200c920b888a119509b6c8c2eea330f0753f2a747f5979aade61'
AND (
token = 'LmPz04zu4lyAJY5tf697xma+08Kyv03fZlgRRu50qb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)