UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9EQDpXMx2yT1PQzja9Mm4OuGOdhmquqB7fd0jsjWYg='
WHERE
key_id = 'b9b81afc149d3abff9e047b21418d311c841ee181d0db5f77259872792a66aca'
AND (
token = 'E9EQDpXMx2yT1PQzja9Mm4OuGOdhmquqB7fd0jsjWYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)