UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DHy86OkJlEkO0qHsZ5M43GEEvzK9qm/RoqNbKK8Yows='
WHERE
key_id = '50913f4e2ba5d07e7741d82f320480fc32d02377051ed00c17a36554349df584'
AND (
token = 'DHy86OkJlEkO0qHsZ5M43GEEvzK9qm/RoqNbKK8Yows='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)