UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8OpdZRkC983cWzW07UJnoI/n3HV0KMH9PotnlvgEcfE='
WHERE
key_id = 'aceb978fbe3fd6690318cb59f973ff0c277137dd6d3fbfb55aeebd7b430f41d4'
AND (
token = '8OpdZRkC983cWzW07UJnoI/n3HV0KMH9PotnlvgEcfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)