UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+dRpBhFSYk+UgGgBXBHv3UQcsWZ8n1aX+sAFUB3TUdU='
WHERE
key_id = 'b10978e2dfe229b9dd7583abeb7df04f95bfcac34c2bc3df98a4ba66a62bbfee'
AND (
token = '+dRpBhFSYk+UgGgBXBHv3UQcsWZ8n1aX+sAFUB3TUdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)