UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKvIJnyq8rGGQET69zbOCex+vda/45q1h1HnvvGZrnU='
WHERE
key_id = 'e8e013e460e4cbfd71cf4fc87264c40c90321d5c15734e07f222193a91b97749'
AND (
token = 'nKvIJnyq8rGGQET69zbOCex+vda/45q1h1HnvvGZrnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)