UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mCrfozJTr+srRh1z9LnzaMI5OxVIvvm4da4bEEPbK+E='
WHERE
key_id = '47cc9368df9074507fada0f25456d27f2476acb62c596f1aeaf50aadf296cbe7'
AND (
token = 'mCrfozJTr+srRh1z9LnzaMI5OxVIvvm4da4bEEPbK+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)