UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tcenbYNEbK3UUvadzfvNZKsUEPUdOvLNPyQ6JgPy1w='
WHERE
key_id = '1b780d3eb5bf552d67ed8a3ebb20a81c04ade8967299bb3eb7d855fae58f8064'
AND (
token = '9tcenbYNEbK3UUvadzfvNZKsUEPUdOvLNPyQ6JgPy1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)