UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lzaf036aIpOx6+2Bsug7/tJ8PulF8LiJOwWzp35i5rs='
WHERE
key_id = 'ba1a97d5ab3549422ab22196e91ab5660e209d6955754a8d78499113ba69aefb'
AND (
token = 'lzaf036aIpOx6+2Bsug7/tJ8PulF8LiJOwWzp35i5rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)