UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RIqwH9J9ovVzapG7/ypSXJPVgJmODQrO6LHAK+Afxrk='
WHERE
key_id = '50544fa67772dde7784e2ecd03fca3fa3dfa6c047dff59d988f8f55414fcae27'
AND (
token = 'RIqwH9J9ovVzapG7/ypSXJPVgJmODQrO6LHAK+Afxrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)