UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CVFv9MFF83u9w+UuxcSAj/+gCY58PQ/SXy4DK3nR3bQ='
WHERE
key_id = 'a1f311a671dd17abc012a906b0924b48d2f8e178f06fd2f60ded99434611c188'
AND (
token = 'CVFv9MFF83u9w+UuxcSAj/+gCY58PQ/SXy4DK3nR3bQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)